package com.example.managesystem.mapper;


import org.apache.ibatis.annotations.*;

@Mapper
public interface CompeletedItemFailureMapper {
    /**
     * 查看项目结项审核失败原因
     * @param itemId
     * @return
     */
    @Select("select failure_text from compeleted_failure where item_id = #{itemId} ")
    String LookFailureReason(Integer itemId);

    /**
     * 插入结项审核失败原因
     * @param itemId
     * @param failReason
     */
   @Insert("insert into compeleted_failure(item_id,failure_text) values(#{itemId},#{failReason})")
    void insertFailure(@Param("itemId") Integer itemId, @Param("failReason") String failReason);

}
